Date Range Prompts

Extensive options are available from the field displaying the prompts available for date expressions that use the is within option.

The following options are available:

• Current: Returns all records in which the date occurs in the Current Week, Month, Quarter, or Year.

• Today/ Yesterday: Returns all records in which the date matches the current date (or yesterday).

• To Date : Returns all records in which the date occurred in the last Week, Month, or Year To Date.

• Last: Returns all records in which the date occurred in the Last Week, Month, x Days, x Months, and so on.

• Next: Returns all records in which the date will occur in the Next 14 Days, Next x Months, and so on.

• Last/ Next: Returns all records in which the date occurred in the Last x Days/Months and all records in which the date will occur in the Next x Days/Months.

• All/ Next: Returns all records in which the date has already occurred and all records in which the date will occur within the next x Days/Months.

• Days Ago or More: Returns all records in which the date occurred x (or more) Days Ago.

• Days from Expiration: Returns all records in which date will expire within a given number of days (or date has already expired).

  Functionally, this option works similarly to All / Next, but provides more options appropriate for date expiration.

• Value does not exist: Returns all records in which the date field is empty / blank.

• Value exists: Returns all records in which the date field contains a value (is not empty / blank). 

Maintenance Connection weeks are calculated from Sunday through Saturday.